Skip to main content
TrustRadius
MySQL

MySQL

Overview

What is MySQL?

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

Read more
Recent Reviews

Reliable and easy to use database

9 out of 10
November 20, 2023
It is solving the problem of efficient processing of a decent amount of data sets. Before that, all data was stored in an Excel sheet, …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Product Demos

E-Commerce Website using PHP and MySQL || Project Demo || Part -1

YouTube

Small CRM Project using PHP and MySQL (Free Download)

YouTube

User Registration Form with PHP and MySQL Tutorial 5 - Add Form Validation + Final Demo

YouTube

MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE) | C#

YouTube

MySQL Enterprise Edition [Newer Version Available]

YouTube

C# MySQL database WinForms CRUD Demo. (CREATE,READ,SELECT,UPDATE,DELETE)

YouTube
Return to navigation

Product Details

What is MySQL?

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

MySQL Videos

What is MySQL?
MySQL is one of the most popular database software options for businesses of all sizes. The software is open source, and highly customizable, so users can set up an instance that meets their needs.
While MySQL is a specific product, NoSQL is a type of database that includes a number of available products. Whether a NoSQL (nonrelational database) product or using MySQL (relational database) is right for you greatly depends on the data you are storing, queries, and flexibility.

MySQL Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

MySQL is a popular open-source relational and embedded database, now owned by Oracle.

Microsoft Access, Google Cloud SQL, and Amazon Redshift are common alternatives for MySQL.

Reviewers rate Usability highest, with a score of 10.

The most common users of MySQL are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(964)

Attribute Ratings

Reviews

(1-25 of 64)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use MySQL primarily for the backend database to our corporate intranet. In this case, it powers all the apps that run on this web-based system, including user details (matched against and extending our ldap directory), technical document retrieval, IT helpdesk tickets, and our design change request system.

MySQL allows us to implement an enterprise-grade database in a cost-effective and easily supportable way - we don't have to depend upon proprietary database formats, it has great performance, scales as we need it to, runs on a variety of operating systems, can be easily migrated to new hardware and is easy to securely backup.

Because it is easily and widely connected to, we can also use it in a variety of other apps and as a repository for large amounts of structured data.
  • Stable - it just runs, with minimal downtime or errors
  • Fast - well-structured data is quickly written and read
  • Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
  • Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL
  • Free it from Oracle's grasp! Bring back the old days...
From my own perspective and the tasks that I perform on a daily basis, MySQL is perfect. It has a reasonable footprint, is fast enough and offers the security and flexibility I need.

Everyone has their preferred applications and, no doubt, for larger data warehouses or more intensive applications, MySQL may have its limits, but for the area that I operate in, it's a great match.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We have at least 15 databases with MySQL We have solved our performance and response issues by getting queries fast
  • Great performance in our servers
  • fastly response in our system
  • takes up less disk space and db compre
  • I like because can be used in front of any query at the beginning with select, insert, replace, delete and update.
  • Also, it is a profiling tool for queries that shows information about where MySQL spends time on query.
It is a profiling tool for queries that shows information about where MySQL spends time on query, its performance and response problems by getting queries fast and takes up less disk space,
Rao Tahir | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Due to its friendly user ineterface and extensilbility with upgraded new features, we as full stack developers perfer to user it for storing and reterving our data. The main problem that it has fixed for us will be its feature of supporting large databases. Also, due to the client and utiliy programs that Mysql offers it is one of the best choices for our business needs.
  • Data storage
  • Integration
  • Scalibility
  • Error Messages
  • Query Optimization
  • Version Errors
It has some great features for storing large sets of rows so it is well recommended for storing large chunks of data. As for the less suited, it may be a bit of a hassle while trying to optimise the queries for trying to achieve better performance of the retrieval of data.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is a relational database solution. It is being used as a durable backend database for almost all of our internal applications. Every PROD grade application requires a robust database, which is highly available and robust. MySQL has all of those features and is proven one of the best in the industry. Nowadays, new database solutions are available that store data in JSON, key-value format. MySql stores data in a tabular format which is one of the best ways to store information. It also increases the read speed exponentially if stored in a tabular form, just like MySQL.
  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.
  • Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
  • Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.
If you are looking for a relational database solution, that stores data in tabular format and with high read/write speeds, MySql shall be your choice. MySql has proven its worth for many years and still the same level of effort is going into the product for new features. In case your requirements are for a key-value pair database or graph databases, then MySql would not be an appropriate choice.
Pablo Gonzalez | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Data redundancy is controlled and duplicate data is eliminated, weaknesses between the data are reduced, a process of extracting additional information from the data can be carried out, the data is shared safely, they offer you good maintenance of standards, security is strong against access by unauthorized users, access codes are assigned that will provide security to your data and your team.
  • It is pleasing to see the visible improvement f in data accessibility since the query language is applied.
  • It is like a huge repository where we get to store huge sets of information or data.
  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.
We have obtained greater speed to perform tasks specifically related to the manipulation of information. It is convenient to remotely access company, product, and business data. Purging logs is extremely easy. Failover services are optimized thanks to backups. You just have to start running the backup, and you can move that copy with your data to other servers.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Many of our applications are built on MySQL DB with different application layer platforms such as PHP web applications and java desktop applications. with stable backend relational data management options, MySQL gives robust and flexible database infrastructure to proceed with dynamic application requirements. also, MySQL's native capabilities are helpful to reduce complexity of operations.
  • DB optimizations
  • Database CRUD accuracy
  • High stability
  • More flexible replication options
  • Automated query optimizations
  • More DB engines
MySQL provided very stable data base management platform to our applications with flexible management features. Also MySQL is very low footprint platform with easy database handling. when comparing with some other DBMSs, MySQL proved high storage efficiency and saving of storage space with large data sets and applications. suggest to have more native tools for replication eco systems with different locations.
Rohit Goyal | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
I use Mysql in my organisation to save the data of our application and maintain historical data of our application and user data and logging data. Mysql is very compatible with all the frontend applications build in any languages, which helps us to have durability of the application data and also can perform many scheduled jobs in mysql
  • Atomicity
  • Durability
  • Consistency
  • Isolation
  • My Sql User interface
  • Message Queuing Technology
  • Generate SQL Scripts
Mysql is recommended when we have budget issues in our application and we need to spend less money in backend of the application as this is a open source tool and can give may functionalities, where as if our applications have need for scheduling jobs and scheduling tasks and creating queues mysql is less appropriate
Score 8 out of 10
Vetted Review
Verified User
Incentivized
A client needed MySQL as part of a local server and app (Decisions) for their investment department for day to day analysis. We're required to set up MySQL with each user who needs this set up on their workstation and ensure it's being accessed and used successfully by the Decisions app.
  • Easy Setup
  • Relative Stability
  • Secure
  • Not as efficient with large databases
  • Takes time to get some features up and running
  • Can be hard to scale
MySQL has worked great when it's tied into other business apps and/or databases that aren't too large. Once the databases become too large, it starts becoming more inefficient and has issues at times with file corruption. I don't see MySQL being as scalable as others which can be a problem as growth occurs.
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We are using MySQL in a few of our microservices application databases. We chose MySQL because its easy to use, has a lot of documentation both official and non official, has a large userbase, os easy to maintain and quick to install with fairly minimal configuration. The last bit is arguably most important for us since at the mooment, we need something that can be done quickly to make our application available to the user.
  • Beginner friendly
  • Quick and easy to set up
  • Has a massive userbase
  • Lack of advanced features compared to PostgreSQL or SQL Server
  • Doesn't scale as well as PostgreSQL or SQL Server for large databases
MySQL is really suited for a beginner who wants to use an RDBMS-type database that doesn't need any advanced features. It's also great if you want to spin up something quickly with only a few steps of installation and security configuration.

It might not be for you if you need something that needs to be massively scalable or if you need advanced features.
Alena Burda | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL has helped me to excel in my field of deploying cloud-native applications and provided me a smooth route to carry on my everyday work. I did not face any difficulty getting started, and it offers a customizable interface so that one cannot get stuck in the high burden of the programs. This tool is providing me better data integrity along with better customer service. It is helping me in my online business to a great extent, as I never faced any difficulty in any transaction and it provides a high-speed transactional processing system.
  • It has hit every nook and corner of my entire organization and I am very much satisfied with its high availability, self-healing, provisioning, monitoring, and much more.
  • It works faster and gives effective services.
  • My team is at ease to work on such a reliable platform that is concerned with security. It provides me full control over all aspects of MySQL through its comprehensive set of advanced features, management tools, and technical support as well.
  • It is the most reliable database management tool that collaborates really well with WordPress, Drupal, Joomla!, etc., and equips me with all the necessary tools that could be beneficial to meet database challenges of next-generation web and cloud services.
  • This is a very costly tool that really does not fit well with small business setups.
  • There are still many complications (e.g., I faced difficulty in its licensing and its UI/UX could be improved too). Also, it is complicated in understand, as too much of the information is available--it becomes difficult to understand.
There are different plans available, so it offers you diversity to choose the one that fits your needs. Furthermore, I believe that through this tool, you will have a transparent idea about the entire processing of your daily work. For me, it’s a universal platform and provides you great security along with data management, so I will recommend you to use it, especially if you deal in e-commerce. This superb tool gives you a clear-cut idea about the processing of your work.
May 01, 2021

My review of MySQL

Xialin Zhu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Most of our internal applications use MySQL as their database. For example, our team owns a JVM tuning & testing platform will need to store each request coming to the platform and their status. We choose MySQL as our database.
  • Easy to set up
  • Easy to learn for beginners
  • Multi-language support
  • Scalability.
  • Not efficient to handle big data sets.
MySQL is the best choice when you are not dealing with big data.
Adolfo Maltez | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
We use MySQL as a RDBMS in a variety of web systems across the entire organization. It's very easy to use, install, and support multiple configurations for a variety of use cases. MySQL has helped us to improve our response time in providing database infrastructure to a wide variety of projects.
  • Easy of use
  • Fast installation
  • Support for replication and backups
  • Free software
  • Standard GUI
  • Blueprints of configuration
  • Better tutorials
MySQL fits use cases that require fast responses, like transactional websites when the user requires a response in no time. Another use case is when we need replications master/slave or multi-master.

The use cases I don't recommend it for are when we need a strong relational database. In that case, MySQL can be a little slow.
April 16, 2021

MySQL--Best RDBMS

Score 9 out of 10
Vetted Review
Verified User
Incentivized
In my team, we are using MySQL as a relational database management system for internal software development projects. It helps us to store data in a well organized and systematic format, which, in return, results in better management, less utilization of resources, and time savings.










  • Very easy and simple to learn and apply
  • Robust and secure
  • Compatible with almost all types of programming languages, like C#, Java, and PHP, which provides flexibility to deploy databases for different applications
  • Not suitable for large data management
  • User interface can be improved
  • Support for non-relational data will be an added advantage
  • Security updates are not that frequent
MySQL can be used easily for web applications and small to medium-sized desktop applications for data management. It is fast, secure, and reliable, which offers easy data management.
Yaniv Vararu | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
MySQL is serving more than one department in our organization. In the R&D department, it's being used as part of our software development. Other departments such as product, customer success, support, business development, and more are using it for managing the customers, for getting analytics, for creating reports and dashboards, and acting by this data.
  • Since MySQL is open source, it is free to use under the GNU license
  • Before any update to data, it pops up a summary for approval, which lowers the risk of making a mistake
  • Performance is great if you need a relatively small DB
  • Compatible with many operating systems and integrates with many development tools
  • If you need a big/huge RDBMS, MySQL is probably not for you (performance-wise)
  • Complex joins/transaction handling causes temp hangs and performance issues--this can be improved
  • Fine tuning is not that easy--you'll probably need an expert (in-house or outsourced) for it
MySQL is best suited for us in managing our customers' definitions, accounts' structures, configurations, etc.--anything that is being set up once and updated only once in a while (and grown at low scales). The data of our customers' actions in the system is not saved in the MySQL DB since this changes in real time every second and this type of DB is less suited for so much data and such frequent changes.
April 12, 2021

MySQL works well

Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used as our relational data store for information in support of our software platform - software as a service for internal communications and employee experience. It is used across the entire product offering for frequently accessed and transactional data with multiple instances including master, failover, and read replicas.
  • Very quick to get up and running - easy to use.
  • It can run on very small virtual machines
  • It performs well and is flexible
  • MySQL always consumes all the memory available on a box and sometimes releasing resources can be an issue.
  • There are certain commands that can get you into trouble and create corruption which is not easily remedied.
  • Transaction handling is not the most efficient and larger databases can take some performance hits.
MySQL is well suited for anyone who needs a relational database and is working within a budget. Since it is open source, it is free to use and has most of the features of something like Oracle or MS SQL Server. MySQL can struggle a little with larger applications and storing the data cache in RAM requires fairly robust machines.
Manav Goel | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used by the whole company. This is a very useful structured database managing tool which helps us in our day-to-day data mining and creating excel with this huge data. The best part of it is if we accidentally make any wrong inputs while capturing any of the data details in our day-to-day activity it can be very easily fixed for a long list of sheets in a single go with a set of queries. MySQL provides the best way to interact with the SQL database. It offers the best available security toward SQL database and maintenance also it takes care of large databases to be optimised and responsive to every action.
  • Data security- MySQL provides a very high-level of security.
  • High performance-MySQL provides very high performance in terms of data mining . A huge amount of data can be easily extracted in couple of seconds.
  • Easy management - This is very easy to manage and easy to demo to employees so they can get hands on quicly.
  • I would say it has few stability issues. It crashed for me, but this is very rare.
  • Another thing is definitely a user cannot start using this right away without any training.
MySQL is best suited in extracting and storing data in different databases and I feel this is a very easy-to-use tool.
November 04, 2019

MySQL - Old User's Review

Holman Cárdenas, M.Eng, TOGAF®, ITIL® | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
I have used MySQL across different companies, mainly as a DB for web pages (along with Apache and PHP) and web-based applications (internal and external). It provides a fast, reliable and efficient DB solution.
  • Very fast and reliable DB
  • Innodb tables are a huge improvement
  • Works very good with the open-source ecosystem, even though it was adquired by Oracle
  • InnoDB tables performance could be improved
  • Tuning is a little bit complex
  • InnoDB tables do not support full-text searches
MySQL is well suited when you are using web pages or web applications in an open-source ecosystem (i.e. Php, Apache) and/or CMS as Joomla, Drupal, WordPress, etc. Not recommended for core or critical-mission applications (it stills need a higher maturity level).
Score 8 out of 10
Vetted Review
Verified User
Incentivized
MySQL is used in the whole organization, for variety of engineering and business purposes. Examples of uses:
  • DevOps pipelines data
  • Software artifact data and metadata
  • Test results
  • Validation results
  • Users and their associated data
  • Extracts from Big Data systems
MySQL is a data store many users are familiar with, and that makes for easy adoption. The infrastructure teams have experience in running it reliably.
  • Popular
  • Improving capabilities over time
  • Widespread knowledge
  • Reactive APIs
  • NoSQL support
  • Graph data models
  • Conventional relational data model
  • Small and medium data sets work well
  • For large data sets consider enhancements like Vitesse
  • The new JSON document support is an excellent addition. This enables us to eliminate some NoSQL document stores (for example, MongoDB or CouchDB, Couchbase) and instead use only one database for various uses.
  • The development and support team are familiar with RDBMS.
September 18, 2019

I like data.

Score 10 out of 10
Vetted Review
Verified User
Incentivized
MySQL is mostly for vetting out developers to make sure they had enough knowledge to accomplish specific job duties. I created a bunch of tables and relationships, and populated a couple hundred rows of data across all of the tables. Then I gave developers a test asking them to send me back SQL scripts to perform various SQL, DDL, DML tasks and I would validate everything to make sure it worked as it ought to.
  • Easy to spin up a database instance.
  • Fast.
  • Not great for dealing with large amounts of data.
  • Limited capabilities for stored procedures.
MySQL is good for simple databases for small projects.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
MySQL is being used by our core team to develop and test out our prototype applications. It is lightweight, easy to use, and offers plugins for almost all of the widely used programming languages. Thanks to MySQL, spinning up a database to back prototype applications is a quick process. The rest of my organization is using Oracle Database 12c.
  • It is designed for Web, Cloud and Big Data. It provides high availability, self-healing and data integrity, provisioning, monitoring and resource management, developer agility, and security.
  • There is complete workflow control, allowing users to tweak all aspects of MySQL.
  • There is a variety of user interfaces that can be implemented, lowering the burden on programmers.
  • Incremental backups take more time and hassle to configure compared to other databases.
  • There is no built-in support for XML and OLAP which hurts business intelligence related analytics.
  • MySQL has gotten farther away from the open-source mentality. MySQL has proprietary and closed-source modules.
It is well-suited for prototyping applications and applications that are not Enterprise scale. Many big names such as Red Hat Enterprise Linux, Fedora, Slackware Linux, and openSUSE, have all switched from MySQL to MariaDB. Hence, for solutions that have longevity concerns in regards to the technologies it is using, MySQL may not be the best option out there.
Aung Phyo | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Incentivized
I use MySQL for database management. I do school projects for web security classes with PHP. We use PHP for the backend and use MySQL for the database. This platform has good security features, and it was very easy to match with PHP and postscript databases.
  • Reliable
  • Fast
  • Can match with most of the framework
  • Hard to match with some frameworks
PHP with MySQL is absolutely perfect.
September 17, 2019

MySQL for the masses

Luka Pavlovic | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use it extensively and it has been great to us. It is simple and fast and a piece of the foundation to any service.
  • Simple to use.
  • Speed
  • Extendable.
  • Features for geocodes.
Anytime I start up a new project, whether personal or professional, I need to start with organizing my data. It’s always MySQL paired with an ORM. It is my go-to and will continue to be moving forward.
September 17, 2019

MySQL is for all!

Alper Ozdamar | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We used MySQL at my previous job. We had a WhatsApp like application named Wirofon. We were using a MySQL database to store subscribers information and for call routing and call barring rules.
  • Easy to deploy
  • Easy to manage
  • Free
  • Scalability
  • Reverse engineering tools
MySQL is well suited if you are working with user data. I used MySQL in many applications (i.e. on a VOIP backend side).
Score 6 out of 10
Vetted Review
Verified User
Incentivized
MySQL is being used to log datasets from a series of electro-mechanical devices (due to NDA, I cannot discuss the specifics). These devices are mechanical in nature, with sensors monitoring properties of the devices. In this particular context, I am looking for failure points and building risk models around those points. However, I have looked at multiple databases for this particular project, and without a doubt, MySql is my favorite as it's simple to set up, and works seamlessly with a LAMP (Linux, Apache, MySql, Php) installation), which really is the selling point here.
  • Speed: returning results from broad queries are a breeze.
  • High Availability: some of the central themes in MySQL are open source. As a result, no "Patch Tuesdays."
  • TCO: The fact that MySQL is an open source project, coupled with strong support and a low failure rate, make its overall total cost of ownership very low and extremely easy to introduce into a lab or research project.
  • Language support: I know this is a little far fetched, but moving from one RDBMS to another is, at times, jarring. I'd like to see some compatibility with other household names (i.e. SQL Server).
  • Along the same line, relaxing the syntax constraints would be nice (i.e. yes/no on the semicolon. Make it optional).
  • MySql needs to develop its features so that it maintains compatibility with more robust and common RDBMS (i.e. Oracle/SQL SERVER).
  • Oracle: Oracle should really think about this: is MySQL so different from their other flagship products that they feel they need to maintain it? Why not roll it up into a single, powerful tech?
By far, the most common reason to use MySQL (mine included, initially) is that you cannot have a LAMP stack without MySQL. Every shred of documentation (almost) on the web implements MySQL as apart of a LAMP stack, and I feel this is truly where MySQL shines. It's packaged, and it performs very similarly to other technologies, and as a result, creates a niche market for itself. Perhaps the future of MySQL will be something like a front-end to other DBs, or perhaps they will pivot from relational to something like document or object. Just a thought.
February 07, 2019

MySQL: Best DBMS

Score 9 out of 10
Vetted Review
Verified User
Incentivized
It is used as a database for the website and application development in our organization. It is used by the technical department in our office. MySQL is a relational database management system which we can use in phpMyadmin and use to save data and work with data while developing a web application or websites.
  • It is really powerful in terms of speed, indexing, and data storing and fetching.
  • It is completely free so anyone can start using it if you are developing websites or applications.
  • Memory issues. If we have to fetch data from millions of rows, it lacks in speed and memory.
  • One needs to learn the SQL language to work with it.
It is well suited for beginners if they are starting out in the development field and need a database system for their applications or websites. You can start installing it and work with phpMyadmin, but you must know the structured query language for using it.
Return to navigation